My Stuff
Community Articles: What Topic Should We Cover Next? Your idea could be our next feature—drop your suggestion now and spark the next big discussion!
-
Re: Formula for Business days
Hi @Dwight Schrute, If your startdate = {datecreated} and enddate=nvl({trandate},{today}), then you just substitute these in the formula. You will come up with something like this: ROUND(((TO_CHAR(nv…2 -
Re: How can I disable the notification below on the image when I include an item in a transaction
Hi @Alexsandro_Brazil_Oracle, To remove this warning, navigate to Home > Set Preference > unmark Inventory Level Warnings. Hope this information helps! ? If it did. then we would greatly apprec…2 -
Re: saved search to verify if admins have modified any JEs after approved JEs
Hi @Jyothi B, Maybe you can add a formula in the Criteria tab > Summary subtab: Formula: MAX(CASE WHEN {systemnotes.type} IN ('Set','Change','Unset') AND {systemnotes…2 -
Re: Saved Search - Price Levels
Hi @Wendy_M, In an Item Saved Search, you can use a Formula (Currency) field with this formula in the Results tab: CASE WHEN {pricing.pricelevel} = 'Name of Price Level' THEN {pricing.unitp…1 -
Re: Report to Show How Long Product Has Been in eComm Location
Hi @Martha Hakes, For the Inventory Turnover Report, the date range selected must span no more than 13 months, so if there is no data within 13 months for the item, then it will not show any data on …1
